UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rXZAnV4vIpdg4NMNotGhzQG9pgg5tbEUtWpcg8bt2bg='
WHERE
key_id = '5d12de94e36ae4a6dafd41d8aa8c2d19f5ad74d40b1301d892dd21f4c19fe4ef'
AND (
token = 'rXZAnV4vIpdg4NMNotGhzQG9pgg5tbEUtWpcg8bt2bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)