UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HeJfY2yVzPKXiNe8GnjLYI3QqsduaQLcfkxN18M4WQ='
WHERE
key_id = '407dd8c921ba709529d33149e654051fcc4c5bab4c5225c8d9a9288598d04917'
AND (
token = '0HeJfY2yVzPKXiNe8GnjLYI3QqsduaQLcfkxN18M4WQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)