UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5yM9MwbStrysGA4F/9M31l/sZtS76b96ebZoMBtkVoc='
WHERE
key_id = 'd9d8cc4bf17caeff4c68bda642c14026db264727b10e12107ec548118fe8df25'
AND (
token = '5yM9MwbStrysGA4F/9M31l/sZtS76b96ebZoMBtkVoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)