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