UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PvN8uRQulbBDTbVIpYbG0LM7JkVQglqniXjVuKbDehE='
WHERE
key_id = 'c4b5305a2671486c8da4d3637a11c46b842e5c00ff9c4d7dfc41d0d6389de498'
AND (
token = 'PvN8uRQulbBDTbVIpYbG0LM7JkVQglqniXjVuKbDehE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)