UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9cVOH2DgY/2nbBHOmgmt2CQ7NTSN6dcvHFQ99oJ1Ng='
WHERE
key_id = '2783eb139939c135a4c72b8e1add50f23fc7f4605c868dadb2666fe45064fedd'
AND (
token = 'U9cVOH2DgY/2nbBHOmgmt2CQ7NTSN6dcvHFQ99oJ1Ng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)