UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8UTzrSLj984JDSO3sY5LZFc9uKCt2FCJcar4ICbiVCc='
WHERE
key_id = 'd235876e1afa8f061c364479a92a72a8a3cdd415dfb88b52af9569a0590e06d2'
AND (
token = '8UTzrSLj984JDSO3sY5LZFc9uKCt2FCJcar4ICbiVCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)