UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sGLM+NY6XeP+qaKTRM+CIkPG9qwSCCK/yPN2m/nXVx8='
WHERE
key_id = 'bdd2fb8775e6b6ea411791f6bbf0bf119a26dbcb5d2d535217b715fa93e3e2e3'
AND (
token = 'sGLM+NY6XeP+qaKTRM+CIkPG9qwSCCK/yPN2m/nXVx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)