UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cFQHAX1UlcnVCuOpEFVB76hRoDxCvjZBzNtEqxbt1Us='
WHERE
key_id = '97cb3e0fe1529cd1a3b4623d0f649d9d39489e9984e4e9dfb16c6c18375eff9a'
AND (
token = 'cFQHAX1UlcnVCuOpEFVB76hRoDxCvjZBzNtEqxbt1Us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)