UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NjKjvC9/NpiAJFJxa28SnfnIl1J3sxURoOHVe4h3O70='
WHERE
key_id = '2cc9275cde623faca646751c227ba6363461a5955bfa41380a5c961a9ddc270e'
AND (
token = 'NjKjvC9/NpiAJFJxa28SnfnIl1J3sxURoOHVe4h3O70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)