UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGpp8whTXxkdeYx6BmDVYxdXnFwfVX8AKxs/SXXRAAU='
WHERE
key_id = 'a773c9cb60145f7637c18f22d74e9596f3f6d2ee86814d5b41286b47ec819e96'
AND (
token = 'CGpp8whTXxkdeYx6BmDVYxdXnFwfVX8AKxs/SXXRAAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)