UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q6aqPTVKd8kntviHscBxCN3zeo/IF25aC1Ta9TYINyU='
WHERE
key_id = '80c023a4e01f07255d6cf1c81645a5a43005515aad6648b47a61951bb141b53b'
AND (
token = 'Q6aqPTVKd8kntviHscBxCN3zeo/IF25aC1Ta9TYINyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)