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