UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'smN67eATg1okGq0twOKsNIb21FauG2LZR/T294aP738='
WHERE
key_id = '0e8413e6893d099c865f94f2908d616a00c6d1c15f3b5ef14dc27803ba4cb534'
AND (
token = 'smN67eATg1okGq0twOKsNIb21FauG2LZR/T294aP738='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)