UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nkXMbUAOgEKjFEpzmlXjwvvyN3CF5CN5UIdrPrBGPb4='
WHERE
key_id = '9c7388cdc489b770e324a658fed85627a72a58951e788fec7691e0353051e4c4'
AND (
token = 'nkXMbUAOgEKjFEpzmlXjwvvyN3CF5CN5UIdrPrBGPb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)