UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xr1m2EF34YKcTrCMBi2n4F24zMPhBGHb02WFF+/EIXc='
WHERE
key_id = '6cd1ea97db235fb9f62aad741e49f65ea0e35842314beda8bb315aa5215c4a2b'
AND (
token = 'Xr1m2EF34YKcTrCMBi2n4F24zMPhBGHb02WFF+/EIXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)