UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1HMQuRSSlwRTyrbBwfSN5Yem/BygPVMlU3i3tg9aPYk='
WHERE
key_id = 'a7fa535403894a36f9dbfb268aaf77a04349842967b90889345c6754d396c682'
AND (
token = '1HMQuRSSlwRTyrbBwfSN5Yem/BygPVMlU3i3tg9aPYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)