UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZmT03TpUMZnxiNFCY0FnbujTfAGAY9k3718C/g4Yeo='
WHERE
key_id = '6edfb1184ad7787f12d3753704da004f6686eb5c27a82c34229c956eae1561ed'
AND (
token = '0ZmT03TpUMZnxiNFCY0FnbujTfAGAY9k3718C/g4Yeo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)