UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIrPT5OLPwwpLQk0kFONbx5XuQcA6u/z99TGW4N2c8M='
WHERE
key_id = 'e0439a0f1e72c167be7b7e75c3c59b2dbefb0c5dd3486de90111bf5cdd34787a'
AND (
token = 'mIrPT5OLPwwpLQk0kFONbx5XuQcA6u/z99TGW4N2c8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)