UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bnUcyYe1XTF9aDppFiRZPUEIDvN399TNh03gUEc6HXI='
WHERE
key_id = 'd94cff44f7f99f10c3d9537cad47e11617302ae6a304c412d00a4c1564a000e0'
AND (
token = 'bnUcyYe1XTF9aDppFiRZPUEIDvN399TNh03gUEc6HXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)