UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nfflq0UCs6Uz0kuQIs1trMkIYoraAISh+bqXOask8rU='
WHERE
key_id = 'b0f9cdea43148aada2a93201ab00a157d2adfa5c3492a8c118a6b3119efc9c83'
AND (
token = 'nfflq0UCs6Uz0kuQIs1trMkIYoraAISh+bqXOask8rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)