UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cA7ie0IyRn1ieEGGzP5P0iY1sdHc+v36R/jl3+3Nz8E='
WHERE
key_id = 'd8f9cc2a469c231bc8dbcafa2c4ad3aca1b9de63d2fa67eec9d276ac2e4ac110'
AND (
token = 'cA7ie0IyRn1ieEGGzP5P0iY1sdHc+v36R/jl3+3Nz8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)