UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l+hFQafO9hsJrRyqA6mNzaLfjC5DlYc3JqRjmc7XPmI='
WHERE
key_id = 'b20496f772132bff161fb7b0e685082f12d9011a71a290f3caa7e5c78a465833'
AND (
token = 'l+hFQafO9hsJrRyqA6mNzaLfjC5DlYc3JqRjmc7XPmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)