UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWM9rtgDyypkpvpo04ta4nucHGnux70JlJ0F3vjl7qM='
WHERE
key_id = '4f8481f90510f479d308f673189dd61c7d0fe482e0b3d2d678d0d5a4411987bd'
AND (
token = 'VWM9rtgDyypkpvpo04ta4nucHGnux70JlJ0F3vjl7qM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)