UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7PbUiAoa5VyOv66A+pE1BXdDQj+sKVVZW7MWlfFVtiQ='
WHERE
key_id = 'b6d346ddebfd3c9cc5b2c7b939fe62ec00cf53c1c6a737eae94f2b1e4a5f965e'
AND (
token = '7PbUiAoa5VyOv66A+pE1BXdDQj+sKVVZW7MWlfFVtiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)