UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fOXDQ33rT6GHNI+HsELQTGLOC8/eCsj+o4uE6i2/xGg='
WHERE
key_id = 'ae9872367ee30c0e14fa61e96da4f07f87ca9df77cedaf2de4932f25dd8cbc11'
AND (
token = 'fOXDQ33rT6GHNI+HsELQTGLOC8/eCsj+o4uE6i2/xGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)