UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mYiiPhaJraA/pK3Cy0eraZZ1pNT+Odv/RQ8zGyyOJ+A='
WHERE
key_id = 'ac071aba1841ff4479408cebbd8f4a7d7d7ba528617b900649db01d982ff51d0'
AND (
token = 'mYiiPhaJraA/pK3Cy0eraZZ1pNT+Odv/RQ8zGyyOJ+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)