UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IBN+y2hpyAWO8oR2p6zOKXNV6uBoihZFExBTpWvzM7M='
WHERE
key_id = '3f6b94e0780a62a05f270008f2bc480238f626ca13b665142e94daf97a03505a'
AND (
token = 'IBN+y2hpyAWO8oR2p6zOKXNV6uBoihZFExBTpWvzM7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)