UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EG0+Y+QsBUe9J637m5X7HUlYZKzsiYU3047b7VUtFw0='
WHERE
key_id = '0be2339484d560d4bab5bff5cc72700e488b645d49aaec425b78758b0e092bfe'
AND (
token = 'EG0+Y+QsBUe9J637m5X7HUlYZKzsiYU3047b7VUtFw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)