UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1HFENqnx7YB23W03IQwG0r8nH6yUmW1PVWtm0yL5yQY='
WHERE
key_id = '184d7305f31780b8c148f1f3c78d5679f1e3211f65f34c5d529fdb978387b824'
AND (
token = '1HFENqnx7YB23W03IQwG0r8nH6yUmW1PVWtm0yL5yQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)