UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TU+zhNZkUzRq48abN+16gfeWMqdSUsTlRKYKUn1e3kM='
WHERE
key_id = '8444d78ef76ddd464468f487bef3aad88f7b52a2f25a8bcdea8d68d418bb31cd'
AND (
token = 'TU+zhNZkUzRq48abN+16gfeWMqdSUsTlRKYKUn1e3kM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)