UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKQx8cDzTLF9WkG0TVEGv/NabmJF78nB+6ak3XezcX4='
WHERE
key_id = '7bcc31fb1fe039f4429dde54e57e26d8da5751d30b81ab3dea277bd3ffbcb02a'
AND (
token = 'zKQx8cDzTLF9WkG0TVEGv/NabmJF78nB+6ak3XezcX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)