UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GsZHHVktMx1pWFql/hljaXvcD5x0ozlkd0Ed23TqRI='
WHERE
key_id = 'b584dfa1cddf8bcf79cf48fe805204c6a704489bdbad80de0478dbc4fbe4af8d'
AND (
token = '8GsZHHVktMx1pWFql/hljaXvcD5x0ozlkd0Ed23TqRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)