UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N12nxzM/rB5u6ZmhMO8HudAR7u9v/giwOPq7cI7A8Io='
WHERE
key_id = 'fef77879ef88a589c4081a81685d6a97754710feba78996b37e12b17d9f9f8d0'
AND (
token = 'N12nxzM/rB5u6ZmhMO8HudAR7u9v/giwOPq7cI7A8Io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)