UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ksfYkvaQgUKQSB+2xgMeyusxS25wyk95+WEv9iAFwqU='
WHERE
key_id = '3642a5a1cf002498f917bfc9f049f4b233557f319f0ba5db4dff2ce571467a7b'
AND (
token = 'ksfYkvaQgUKQSB+2xgMeyusxS25wyk95+WEv9iAFwqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)