UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xpXvpDs7T+hrTvb5bRKPIiZeTzpII5EzBh6Op+BeeVo='
WHERE
key_id = '7c172b8d55ea42919d85539e78a444b0e623fb21b68408e66ff2a71f18ad79f3'
AND (
token = 'xpXvpDs7T+hrTvb5bRKPIiZeTzpII5EzBh6Op+BeeVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)