UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hgtqlDhY7/ApM3ys7l5jePeJZnX7FYpxwjUlMhTUdWo='
WHERE
key_id = 'e0f2e475263e9813fdc0267e04aca6530efb05897e21996a71f0025de0665391'
AND (
token = 'hgtqlDhY7/ApM3ys7l5jePeJZnX7FYpxwjUlMhTUdWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)