UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CHTQYdc3H30JAiRYcspjJGMH6OC+tBy8NnlV70nXAsA='
WHERE
key_id = 'd15b164a1fe3c093c4bf8c2e22f51ab226ddb3076a0c503f9d0ee3be43fc8c44'
AND (
token = 'CHTQYdc3H30JAiRYcspjJGMH6OC+tBy8NnlV70nXAsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)