UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJi/D2pRI48zjlJawq6KkuxdTV8srkhwCbmrrV5Opl8='
WHERE
key_id = '29ad2873159f8b992d666a04e73f1d31b836d83bb8672cc4fb2f76c372a61a33'
AND (
token = 'NJi/D2pRI48zjlJawq6KkuxdTV8srkhwCbmrrV5Opl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)