UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSZBDMRgPjKtvoY7fLC1w90uM16XhfpZkMyeM4uWjy0='
WHERE
key_id = 'fe7770ee5a12b2f2872bcebf73f4dde04ea5e963d98522b3651c075319260636'
AND (
token = 'zSZBDMRgPjKtvoY7fLC1w90uM16XhfpZkMyeM4uWjy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)