UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd+zSILiV9F+qFfV6DcpEc8W/+/8UXNpGjUIW5yb+TwY='
WHERE
key_id = '527ec40feca66b734594e560eb1a8113445d606ed2e7730f7621e4e8b2f56b2a'
AND (
token = 'd+zSILiV9F+qFfV6DcpEc8W/+/8UXNpGjUIW5yb+TwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)